FO_LabInfo

This table contains a single row of values used to configure system functions.

 

Field Type Notes

LabInfo_ID

int

ID field, a counter. Unique

LabName

varchar(50)

Laboratory name for the login screen and reports

LabCode

varchar(20)

Code value for this lab.

LabAddress1

varchar(50)

Address field on reports.

LabAddress2

varchar(50)

Second address field on reports.

LabAddress3

varchar(50)

Third address field on reports.

LabAddress4

varchar(50)

Fourth address field on reports.

LabDirector

varchar(50)

Name of lab director on reports.

Misc1

varchar(50)

Login screen user defined field #1.

Misc2

varchar(50)

Login screen user defined field #2.

Misc3

varchar(50)

Login screen user defined field #3.

Misc4

varchar(50)

Login screen user defined field #4.

Misc5

varchar(50)

Login screen user defined field #5.

UseVerify

int

Enter the integer 1

Do NOT change without Rhodes approval.

UseMandatorySteps

int

Enter the integer 1

Do NOT change without Rhodes approval.

Barcode_Security

decimal(18, 2)

Enter the real number 1.00

Do NOT change without Rhodes approval.

Barcode_Xunit

decimal(18, 2)

Enter the real number 150.00

Do NOT change without Rhodes approval.

Barcode_Yunit

decimal(18, 2)

Enter the real number 5.00

Do NOT change without Rhodes approval.

Def_PtLocCode

varchar(20)

System-level default patient location code on the order screen.

Enter a valid patient location code.

This code is only used if no value is in the field when the order is saved.

Def_Epi_Days

int

Enter the integer 30

Do NOT change without Rhodes approval.

Epi_Ins_Options

varchar(100)

Populates Insurance option drop-down list on the Episode Definition screen.

Multidimensional pipe delimited value, with leading and trailing pipes.

Enter valid insurance codes separated by pipes.

IE: |INS1|INS2|INS3|

Epi_BillTo_Options

varchar(100)

Populates Bill To option drop-down list on the Episode Definition screen.

Multidimensional pipe delimited value, with leading and trailing pipes.

Enter valid billto codes separated by pipes.

IE: |P|C|I|

SO_Review_Days

int

System-level default number of days before a standing order expires and requires review.

Enter an integer for the number of days.

Used to calculate the number of days until standing order expiration. Calculation is based on create date of the standing order.

IE: 180

(is this calculated from collection date, create date or ??)

ResultSysURL

varchar(255)

URL to connect to a client-provided lab result portal.

Enter a valid URL.

The URL may contain place holders for user name and password for the client-provided lab system.

IE: HTTP://LabPortal.com /#USERNAME#/#PASSWORD#

BlockMRLength

varchar(80)

Mask for MRN entry value.

Multidimensional pipe delimited value, with leading and trailing pipes.

Enter integers separated by pipes.

Each number represents an MRN entry length that is NOT supported by the system.

IE: |1|2|3|4|5|6|7|9|10|11|12|13|14|

In this example, the MRN entry must be either 8 characters long or longer than 14 characters.

ADT_Interface

varchar(255)

Default value for the Outbound ADT system interface.

Use Rhodes recommended value.

OE_Interface

varchar(255)

Default value for the Outbound OE system interface.

Use Rhodes recommended value.

Result_Interface

varchar(255)

Default value for the Outbound RE system interface.

Use Rhodes recommended value.

LogoImageFile

varchar(255)

The network path and file name for the logo file used on screen and report displays.

Enter a valid network path and file name.

The file must be a GIF or JPG image approximately 100x125 pixels.

DefaultFacilityID

varchar(50)

System-level default facility ID code.

Enter a valid facility ID code.

DefaultSpeciesCode

varchar(50)

Default species code.

H = HUMAN

DefaultSpeciesName

varchar(50)

Default species name corresponding to the default species code.

HUMAN

Def_ClientCode

varchar(50)

System-level default client ID code.

Enter a valid client ID code.

DefOrdScreenReq

varchar(80)

System-level default requisition report name used when the REQ button on the order screen is clicked.

Default used when the user-level value is not defined.

Required value.

Use Rhodes recommended value.

Callback_Callcode

varchar(50)

Value of “Call” for callback systems.

Used when the Call button on the order screen phone definitions is clicked.

Callback_Faxcode

varchar(50)

Value of “Fax” for callback systems.

Used when the Fax button on the order screen phone definitions is clicked.

MRNumGenerationRoutine

varchar(50)

Automatically generates an MRN number on the patient data screen.

Use Rhodes recommended value.

Typical value: ALPHA4NUMBER4

PasswordExpirationDays

int

Number of days before a user password expires and must be reset.

Enter an integer for the number of days.

Def_AreaCode

varchar(50)

System-level default for area code.

Enter an integer for a valid area code.

Used on the patient demographic screen if area code is not provided.

The default area code is inserted into the record when the record is saved if no area code was entered on screen.

AutoOrderCodeWhenCCDoc

varchar(50)

Used to order tests automatically when copy to physician is used on the order screen.

Multidimensional pipe delimited value, with leading and trailing pipes.

Enter valid order test codes separated by pipes.

MRNumMask

varchar(50)

Medical record number mask used to validate the MRN field on the order screen.

Enter “#” to represent numbers and “@” to represent alpha characters.

Typical value: @@@@####

CallToOrderCode

varchar(50)

Used in the mini window for call/fax to automatically order a test code when the Call button is clicked on the order screen.
Enter a valid orderable test code.

FaxToOrderCode

varchar(50)

Used in the mini window for call/fax to automatically order a test code when the Fax button is clicked on the order screen.
Enter a valid orderable test code.

FastingOrderCode

varchar(50)

Used to automatically order a test if the fasting priority is selected at the order level on the order screen. The rule is activated at the time the Verify button is clicked.

Enter a valid orderable test code.

PastOrderDays

int

Number of days back that the system will allow a user to date a new order.

Enter an integer for the number of days.

The collection date is evaluated and if the order is too old, a warning message will be displayed.

FutureOrderDays

int

Number of days in the future that the system will allow a user to date a new order.

Enter an integer for the number of days.

The collection date is evaluated and if the order is too far in the future, a warning message will be displayed.

ReqID_Mask

varchar(50)

Mask used to validate the requisition ID on the order screen.

Enter “#” to represent numbers and “@” to represent alpha characters.

Typical value: ########

This setting requires an 8 character numeric only entry.

ReqID_Exclude_Characters

varchar(80)

Defines the characters to exclude from the requisition ID value.

Multidimensional COMMA delimited value.

Enter the characters, separated by commas, that should be excluded from the requisition ID value on the order screen.

ReqID_Length_Range

varchar(50)

Represents the minimum and maximum number of characters allowed in the requisition ID field on the order screen.

Enter two integers separated by a dash.

Do not enter a value here if an edit mask is defined for the requisition ID field.

If the value is set as '10-15', then an entry between 10 and 15 characters long is allowed.

DefaultPerformingLab

varchar(50)

System-level default performing lab code value.

Enter a valid performing lab code value.

Used to supply a performing lab code to the system when one is required and not provided by rules.

DefaultBatchDestination

varchar(50)

System-level default batch destination code.

Enter a valid batch destination code.

Used if not provided by rules for transport logic.

AccessionFormat

varchar(50)

Drives the routines that create unique FASTaccessions and container IDs.

Use Rhodes recommended value.

Allowed values:

ENTRYGROUPCODE = use entry group code to derive format.

7SEQ = create a 7 character unique number

8SEQ = create a 8 character unique number

9SEQ = create a 9 character unique number

10SEQ = create a 10 character unique number

11SEQ = create a 11 character unique number

12SEQ = create a 12 character unique number

TestCompDupExcludeDept

varchar(50)

Defines the department codes to exclude from the test overlap/duplication logic during order entry.

Multidimensional pipe delimited value, with leading and trailing pipes.

Enter valid department codes separated by pipes.

This value is used to exclude the list of department codes it represents from applying to the test overlap/duplication logic during order entry.

Any department codes in this list will not be evaluated for test overlap.

IE: |BB|MC|CY|PATH|

If this field is blank, the system will default to |MC|BB|CY| and will exclude those departments from test overlap/duplication logic.

DisplayBDEFields

varchar(50)

Determines which fields to display in the blind duplicate entry screen.

Multidimensional pipe delimited value, with leading and trailing pipes.

Enter allowed values shown below separated by pipes.

The default value of |ALL| may be used to display all fields.

If this field is blank, the system will default to |ALL|.

Allowed values:

M = MRN

N = patient name

D = DOB

S = gender

T = telephone

C = client

L = location

P = physician

E = test related fields

CC1 = copy to 1

CC2 = copy to 2

CC3 = copy to 3

CC4 = copy to 4

ADD = address fields

TestCompDupExcludeTests

varchar(500)

Defines the order codes to exclude from the test overlap/duplication logic during order entry.

Multidimensional pipe delimited value, with leading and trailing pipes.

Enter valid order codes separated by pipes.

This value is used to exclude the list of order codes it represents from applying to the test overlap/duplication logic during order entry.

Any order codes in this list will not be evaluated for test overlap.

SalesTaxUserLoc

varchar(100)

Defines the user locations and their corresponding sales tax to be used for price calculations on the payments screen.

Multidimensional pipe delimited value, with leading and trailing pipes.

Enter valid user location code - sales tax percent pairs separated pipes.

Each value in a pair is separated by a dash.

IE: |USERLOC1-6.5|USERLOC2-6|

LabAccessionAlphaCharacters

varchar(50)

Represents the letters used in the lab accession generation when FASTwill pre-generate it and send it to the LIS.

Multidimensional pipe delimited value, with leading and trailing pipes.

Enter single capital letters separated by pipes.

IE: |A|Q|Z|

LabAccessionFormat

varchar(50)

Defines format for creation of lab accession values.

Use Rhodes recommended value.

IE: 1A,8N

The format '1A,8N' generates lab accessions that are one alpha character followed by 8 numeric characters.

PaymentTypes

varchar(100)

Populates the payment type drop-down on the payment screen.

Multidimensional pipe delimited value, with leading and trailing pipes.

Enter valid payment type codes separated by pipes.

IE: |CARD|CHECK|CASH|

PaymentCardTypes

varchar(100)

Populates the credit type drop-down on the payment screen.

Multidimensional pipe delimited value, with leading and trailing pipes.

Enter valid credit card type codes separated by pipes.

IE: |AMEX|VISA|DINNERS|DEBIT|

AutoCCORDCode

varchar(50)

Default test code for the ordering physician when the rule is activated to order a test battery to hold the values of ordering and copy to codes.

The system will automatically enter the physician code for the order if the answer test code matches this value.

Enter a valid test code.

Used to send the ordering / copy to physician values to a client as a test code in a lab report.

AutoCCccCode

varchar(50)

Default test code for copy to physician when the rule is activated to order a test battery to hold the values of ordering and copy to codes.

The system will automatically enter the copy to codes for the order if the answer test code matches this value.

Enter a valid test code.

CollectionLocations

varchar(500)

System-level default for collection location if not defined at the user level.

Enter a valid collection location.

Used to validate the collection location entered on the order screen.

(does this 'evaluate' mean that the field will be filled in with this value if the field is blank when the record is saved? or what?)

CDCOrderEvalHours

int

Represents a number of hours.

Enter an integer for the number of hours.

Default is 0.

Used to validate the collection date/time on the order screen when a previously created order is opened.

If the order collection date/time is older than this value, the collection date/time field is cleared to allow the user to enter a new one.

PtRaceEntries

varchar(255)

Populates the race drop-down on the patient demographics screen.

Multidimensional pipe delimited value, with leading and trailing pipes.

Enter valid race codes separated by pipes.

PtEthnicityEntries

varchar(255)

Populates the ethnicity drop-down on the patient demographics screen.

Multidimensional pipe delimited value, with leading and trailing pipes.

Enter valid ethnicity codes separated by pipes.

FutureOrderSecsAutoReceive

int

Represents a number of seconds.

Enter an integer for the number of seconds.

If the collection date/time is in the future by more than this number of seconds, the accession is excluded from auto receive processes.

FutureOrderSecsNotTriggerLabels

int

Represents a number of seconds.

Enter an integer for the number of seconds.

If the collection date/time is in the future by more than this number of seconds, no label is produced.

CID_Prefix

varchar(50)

Prefix characters for ContainerID.

Enter the character string to use as the prefix for ContainerIDs.

ExceptionExecFolder

varchar(255)

Pathway for CSTools installation.

Enter a valid network path.

IE:

C:\Program Files (x86)\Rhodes\Rhodes Client Service Tools

ExceptionExecutable

varchar(80)

File name for CSTools executable. Include ".exe" in the file name.

IE: ClientServiceTools.exe

OrderActionPhoneNumbers

varchar(255)

Designed for use in TEST area.

Multidimensional pipe delimited value, with leading and trailing pipes.

Enter phone numbers, separated by pipes, to limit user’s choice of entry.

IE:

|1234567894|2625326859|2625327021|

Used to prevent a user from sending play data to real client. Typically, only include values internal to IT group.

RecognizedPrefixes

varchar(255)

Defines the prefixes to remove from patient last name in patient matching rules.

Storage of prefixes depends on permission.

Multidimensional pipe delimited value, with leading and trailing pipes.

Enter patient last name prefixes that should be removed from patient last names via matching rules.

Enter prefixes separated by pipes.

RecognizedSuffixes

varchar(255)

Defines the suffixes to remove from patient last name in patient matching rules.

Storage of suffixes depends on permission.

Multidimensional pipe delimited value, with leading and trailing pipes.

Enter patient last name suffixes that should be removed from patient last names via matching rules.

Enter suffixes separated by pipes.

OrderCollectLocationTypes

varchar(255)

Populates the collection type drop-down on the patient collection location screen.

Multidimensional pipe delimited value, with leading and trailing pipes.

Enter valid collection type codes separated by pipes.

Used to group or classify a set of addresses you have associated to the patient.

For example:

N or NH = nursing home

H = patient's residence

C = health fair or clinic

IE:

|N|H|C|

SendOrderForFPCancelToLIS

bit

Bit flag to indicate if FASTshould trigger a new order message before a cancel message when sending cancellation to LIS.

This would only be true for orders that have not been previously sent to the LIS or have originated in LIS.

The system will evaluate both of these conditions by checking to see if the IFTriggerUpdate field has been filled at the test level.

Enter 0 or 1

0 = do not trigger NW order before cancel

1 = trigger NW Order before sending cancel

TriggerCancelCDCOutbound

bit

Bit flag to indicate if FASTshould trigger cancellation messages to the outbound CDC interface for orders where FO_Accessions.Origin equals ‘C’ or ‘T’.

Enter 0 or 1

0 = do not trigger cancellation messages to outbound CDC

1 = trigger cancellation messages to outbound CDC

TDC_In_Interfaces

varchar(255)

Interface code for Trusted Data Concentrator inbound interface.

Code is written to the interface code field when a trigger row is written by FAST. It must match what is expected for interface to function.

TDC_Out_Interfaces

varchar(255)

Interface code for Trusted Data Concentrator outbound interface.

Code is written to the interface code field when a trigger row is written by FAST. It must match what is expected for interface to function.

CDC_In_Interfaces

varchar(255)

Interface code for Client Data Concentrator inbound interface.

Code is written to the interface code field when a trigger row is written by FAST. It must match what is expected for interface to function.

CDC_Out_Interfaces

varchar(255)

Interface code for Client Data Concentrator outbound interface.

Code is written to the interface code field when a trigger row is written by FAST. It must match what is expected for interface to function.

CDC_OUT_Cancel_Order_Control

varchar(50)

Cancellation order control to be used in FO_IF_Trigger_CDCOutbound.

OrderControl when FAST writes a cancellation trigger.

Enter OC or CA

Code is written to the trigger table when a trigger row is written by FAST.

RecentPatientSearchType

varchar(50)

Default RECENT PTS search type.

Enter an allowed value.

Allowed values:

USERLOCATION

ENTRYGROUPCODE

PTACCESSGROUP

MPI

RecentPatientSearchDays

varchar(50)

Default number of days to evaluate for recent activity.

Enter an integer for the number of days.

Used with RECENT PTS search option.

Based on edit date not create date.

UseInterfaceTriggerService

bit

Bit flag to indicate if FASTshould enable FASTInterface Trigger Layer.

Used in conjunction with FASTInterface Trigger Process Service.

Enter 0 or 1

0 = do not use trigger layer (FASTwill continue to write to trigger table)

1 = use FASTInterface Trigger Layer and FASTInterface Trigger Process Service (started configured and separately)

(A background service for creating application to interface subsystem triggers.

When this is set the application writes general triggers for the background job to process in the table FO_IF_AppTrigger_Queue.

The background job then creates the explicit table updates and the triggering to the FO_ID_Trigger table.)

ProvCodesTriggerFreeText

varchar(255)

Defines provider codes for which a freetext provider name is allowed.

Multidimensional pipe delimited value, with leading and trailing pipes.

Enter valid provider codes separated by pipes.

UseClientDrivenOrderScreen

bit

Bit flag to indicate if client-driven order screen is default order screen.

Enter 0 or 1

0 = use original FASTorder screen

1 = use client-driven order screen

UnknownCollectDate

date

Date sent to LIS when Unknown Collection box is checked.

Enter collect date as MM/DD/YYYY format.

UnknownCollectTime

varchar(50)

Time sent to LIS when Unknown Collection box is checked.

Enter collect time as HH:MM 24-hour format.

SpecimenPresentsDefTechCode

varchar(50)

Default tech code for collection tech in the Specimen Presents mode.

Enter a valid tech code.

MaxOrderCopyToProvs

varchar(50)

Defines the maximum number of 'Copy To' providers allowed per order.

Enter an integer from 0 to 10.

FPtoRREInterfaceCode

varchar(50)

Interface code for the Fast to RRE interface service.

Enter a valid interface code.

LabRegionCode

varchar(50)

Connects a lab code to a larger organization charting process.

Enter a valid region code as defined in an organizations chart.

LabDivisionCode

varchar(50)

Connects a lab code to a larger organization charting process.

Enter a valid division code as defined in an organizations chart.

LabSubDivisionCode

varchar(50)

Connects a lab code to a larger organization charting process.

Enter a valid sub-division code as defined in an organizations chart.

DefaultFeeSchedule

varchar(80)

Default fee schedule for multiple fee schedule implementations.

Enter a valid fee schedule code.

DefaultFeeScheduleOption

varchar(80)

Default option code in the default fee schedule for multiple fee schedule implementations.

Enter a valid fee schedule option code.

WorkFlowMethods

varchar(255)

Workflow methods used by the site.

Populates the workflow method drop-down on the integrated search page.

Multidimensional pipe delimited value, with leading and trailing pipes.

Enter one or more allowed values separated by pipes.

Allowed values:

PATIENT PRESENTS

SPECIMEN PRESENTS

INDUSTRIAL TOX

DefaultWorkFlowMethod

varchar(50)

System-level default workflow.

Overridden by a user location or user-defined default workflow.

Enter an allowed value.

Allowed values:

PATIENT PRESENTS

SPECIMEN PRESENTS

INDUSTRIAL TOX

ITOXDefProviderCode

varchar(50)

Default provider code for orders placed while in ITOX workflow.

Enter a valid provider code.

ITOXDefICDCodeq

varchar(50)

Default diagnosis code for orders placed while in ITOX workflow.

Enter a valid diagnosis code.

PatientFeeSchedule

varchar(80)

Default fee schedule code applied to FASTaccessions labeled with a Bill To value of 'Patient/Guarantor'.

Enter a valid fee schedule code.

PatientFeeScheduleOption

varchar(80)

Default fee schedule option applied to FASTaccessions labeled with a Bill To value of 'Patient/Guarantor'.

Enter valid fee schedule option code.

CashFeeSchedule

varchar(80)

Default fee schedule code applied to FASTaccessions labeled as 'Bill to Cash'.

Enter a valid fee schedule code.

CashFeeScheduleOption

varchar(80)

Default fee schedule option applied to FASTaccessions labeled as 'Bill to Cash'.

Enter a valid fee schedule option code.

PaymentReceiptExternalFormCode

varchar(50)

The form code from FO_External_Form_Definition.

ExternalFormCode that can be used to show a user-customized SSRS-based payment receipt form.

PtDefaultDOB

date

Default DOB.

Enter DOB as MM/DD/YYYY format.

BatchListRPTExternalFormCode

varchar(50)

The form code from FO_External_Form_Definition.

ExternalFormCode that can be used to show a user-customized SSRS-based Batch List form.

Leave blank to use the default report.

DispatchListRPTExternalFormCode

varchar(50)

The external form code for the dispatch list user custom report.

Enter a valid external form code as defined in FO_External_Form_Definition.ExternalFormCode.